﻿CREATE TABLE [dbo].[ASMS_Business]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
	[Number] nvarchar(32),
	[Name] nvarchar(64),
	[ShortName] nvarchar(32),
	[Country] nvarchar(32),
	[Province] nvarchar(32),
	[City] nvarchar(32),
	[District] nvarchar(32),
	[Address] nvarchar(256),
	[PostCode] nvarchar(8),
	[Email] nvarchar(128),
	[Fax] nvarchar(32),
	[ContactName] nvarchar(32),
	[ContactTelephone] nvarchar(32),
	[Telephone] nvarchar(32),
	[QQ] nvarchar(32),
	[Wechat] nvarchar(64),
	[LogoImage] nvarchar(256),
	[Status] int NOT NULL,
	[CreatedTime] datetime NOT NULL,
	[Creator] nvarchar(64) NOT NULL
)
